SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}Cancelada{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}Cancelada{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}Spain{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}Spain{c9b455194fd6a0681da604a73a2e4f01103ab4c0b49973df385439dbad879174}' OR prCountry = 'Spain')